﻿CREATE PROCEDURE [dbo].[UserAccount_GetAll]
AS
SELECT  UserAccountId AS Id, FirstName, LastName, Email, c.CompanyName AS Company FROM UserAccount ua
JOIN Company c ON c.CompanyId = ua.CompanyId